package org.doubango.ngn.utils;

public interface DB_Def {
	public final static String DATABASE_NAME = "BangBangDB";
	public final static int DATABASE_VERSION = 1;
	public final static String TABLE_USER_INFO_NAME = "userInfo";
	public final static String TABLE_RECENT_FRIENDS_NAME = "recentFriends";
	public final static String TABLE_SYSTEM_MESSAGE_NAME = "systemMessage";
	public final static String FIELD_ID = "id";
	public final static String FIELD_USER_ID = "user_id";
	public final static String FIELD_PASSWORD = "password";
	public final static String FIELD_TO_ID = "toId";
	public final static String FIELD_FROM_ID = "fromeId";
	public final static String FIELD_SYSTEM_MESSAGE = "message";
	public final static String FIELD_IS_NEW ="is_new";
	public final static String FIELD_TIME = "friendTime";
	public final static String FIELD_FRIEND_ID = "friendId";
	public final static String FIELD_FRIEND_MESSAGE = "message";
	public final static String FIELD_FRIEND_TIME = "friendTime";
	public final static String[][] TABLE_ST ={
		{TABLE_USER_INFO_NAME,FIELD_ID+" integer primary key autoincrement,"+FIELD_USER_ID+" text,"+FIELD_PASSWORD+" text"},
		{TABLE_RECENT_FRIENDS_NAME,FIELD_ID+" integer primary key autoincrement,"+FIELD_USER_ID+" text,"+FIELD_FRIEND_ID+" text, "+FIELD_FRIEND_MESSAGE+" text, "+FIELD_FRIEND_TIME+" long"},
		{TABLE_SYSTEM_MESSAGE_NAME,FIELD_ID+" integer primary key autoincrement,"+FIELD_USER_ID+" text,"+FIELD_TO_ID+" text, "+FIELD_FROM_ID+" text, "+FIELD_SYSTEM_MESSAGE+" text, "+FIELD_IS_NEW+" boolean, "+FIELD_TIME+" long"},
	};
}
